How many characters can be typed in a single cell in Excel?
Answer: D
Correct answer: 32,000
A cell holds up to 32,767 characters of text, of which about a thousand are displayed unless the row is enlarged. Of the figures offered, 32,000 is the one that reflects it.
Please log in or register to report this question.
In MS Excel, what is a circular reference?
Answer: C
Correct answer: A formula that refers, directly or indirectly, to its own cell
A circular reference occurs when a formula depends on its own cell, either directly - =A1+1 typed into A1 - or through a chain that eventually comes back to it. Excel cannot resolve it, since the answer would depend on itself, so it displays a warning, shows zero, and names the offending cell in the status bar. The full list is found under Formulas, Error Checking, Circular References. The usual cause is accidental: a SUM formula placed inside the range it is adding, most often at the bottom of a column where the range was extended one row too far. Deliberate circularity is possible where a genuinely iterative calculation is intended, by enabling Iterative Calculation in Excel’s options and setting a maximum number of iterations and a change threshold. That is used for engineering and financial models that converge, and should not be left on by default, since it silently masks accidental circular references.
Please log in or register to report this question.
In MS Excel, a cell reference written as Sheet2!B5 refers to
Answer: C
Correct answer: cell B5 on the worksheet named Sheet2
The exclamation mark separates the sheet name from the cell address, so Sheet2!B5 is cell B5 on the sheet called Sheet2. If the sheet name contains a space or a punctuation mark it must be enclosed in single quotation marks: ='Sales Data'!B5. Excel adds them automatically when a reference is built by clicking. A reference to another workbook adds the file name in square brackets: =[Budget.xlsx]Sheet1!A1. That creates a link, which prompts to update when the file is opened and breaks if the source is moved or renamed. Links are managed from Data, Edit Links. A 3-D reference spans several sheets: =SUM(Jan:Dec!B5) adds B5 across twelve monthly sheets, which is how identical sheets are consolidated. Renaming a sheet updates every formula referring to it automatically, which is one reason to rename rather than recreate.
Please log in or register to report this question.
Comments on a presentation can record who wrote them and when they were added. What's the automatic way in PowerPoint 2002?
Answer: C
Correct answer: Use comments
Insert → Comment attaches a note to a slide and stamps it automatically with the reviewer’s name and the date, taken from the User Information settings - nothing has to be typed by hand. The notes page is free text with no author or date, and online collaboration is a meeting facility rather than a way of recording remarks.
Please log in or register to report this question.
Files created with Lotus 1-2-3 have an extension
Answer: C
Correct answer: 123
Lotus 1-2-3 files carry the extension .123 in its later versions; the earlier releases used .WK1 and .WK3, which is why that option is also on the list.
Please log in or register to report this question.
In notes master view, how do you modify the font size of text for all hte4 notes of a presentation?
Answer: C
Correct answer: Modify the text within the body placeholder
Notes Master view shows the notes body as a placeholder. Selecting the text inside that placeholder and changing its font size resets the size for the notes of every slide at once. Changing the slide design affects slides, not notes, and moving the placeholder around alters the layout without touching the type size.
Please log in or register to report this question.
The autofill feature
Answer: A
Correct answer: Extends a sequential series of data
AutoFill continues a pattern: dragging the fill handle from cells containing 1 and 2 gives 3, 4, 5, and from Mon gives the rest of the week. It recognises the series rather than adding anything up.
Please log in or register to report this question.
What PowerPoint feature will you use to apply motion effects to different objects of a slide?
Answer: D
Correct answer: Animation Scheme
An animation scheme applies a ready-made set of entrance and emphasis effects to the objects on a slide. Slide transition governs the change between slides rather than movement within one.
Please log in or register to report this question.
The autofill feature
Answer: D
Correct answer: extends a sequential series of data
AutoFill continues a pattern: from 1 and 2 it gives 3, 4, 5, and from Jan it gives the rest of the months. It recognises the series rather than adding anything up.
Please log in or register to report this question.
Slide show options available to the presenter include all of the following except
Answer: A
Correct answer: Transitions command
The shortcut menu shown during a running slide show offers navigation commands, speaker notes and the meeting reminder, but transitions must be set beforehand in the editing views - there is no command to change them while the show is running.
Please log in or register to report this question.
