You can edit an embedded organization chart object by
Answer: D
Correct answer: b and c both
An embedded chart is edited either by double-clicking it or by right-clicking and choosing the edit command for that object type - two routes to the same in-place editing.
Please log in or register to report this question.
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Answer: B
Correct answer: Apply Conditional Formatting command on Format menu
Conditional formatting applies a format when a condition holds, and re-evaluates it whenever the value changes. An IF function returns a value rather than a format, and formatting the cells by hand would not follow later edits.
Please log in or register to report this question.
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….
Answer: D
Correct answer: B1:G10
A range is written as its top-left and bottom-right corners joined by a colon: B1:G10. The semicolon and the full stop are not Excel's range operators.
Please log in or register to report this question.
Which of the following features should you use when typing in the notes text box?
Answer: D
Correct answer: Zoom
The notes text box in Normal view is small, so the text is displayed at a reduced percentage and is hard to read while typing. Raising the Zoom level enlarges the pane on screen without changing the printed size. Slide Show runs the presentation, Insert adds objects, and the Slide Master governs formatting - none of them make the notes pane easier to read.
Please log in or register to report this question.
What is defined by the handout master?
Answer: B
Correct answer: Layout of audience handout notes
The handout master controls how printed handouts are arranged - how many slide thumbnails appear per page, where they sit, and the header, footer, date and page-number placeholders. It does not touch slide formatting, which belongs to the slide master, nor the Word export formatting.
Please log in or register to report this question.
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Answer: D
Correct answer: All of above
AutoFormat's options let you switch each element on or off individually - number, border, font, patterns, alignment and width or height - so an existing font can be kept while the borders are applied.
Please log in or register to report this question.
Status indicators are located on the
Answer: C
Correct answer: Formula bar
The status indicators - Ready, Enter, Edit, Point - sit at the left of the status bar area associated with the formula bar and tell you what mode the cell is in.
Please log in or register to report this question.
The chart wizard term data series refers to
Answer: B
Correct answer: A collection of chart data markers
A data series is one row or column of values, drawn as a set of markers of the same colour - one line, or one set of bars. The legend names the series rather than being one.
Please log in or register to report this question.
Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
Answer: A
Correct answer: IF
AND, OR and NOT return TRUE or FALSE and nothing else. IF tests a condition and then returns whichever of two values it is given, so its result can be anything at all.
Please log in or register to report this question.
Macros are “run” or executed from the ….. menu.
Answer: C
Correct answer: Tools
Macros are recorded, run and edited from Tools > Macro.
Please log in or register to report this question.
