You can copy data or formulas
Answer: D
Correct answer: All of the above
Copying is available from the Edit menu, from the right-click shortcut menu, from the toolbar buttons and from the keyboard - four routes to the same command.
Please log in or register to report this question.
Which among the following will not set text in selected cells to italics?
Answer: B
Correct answer: Using the Tools – Wizard – Web Form menu item
Italics can be applied with Ctrl + I, with the Italic button on the Formatting toolbar, or through Format → Cells → Font. The Tools → Wizard → Web Form command builds a web form and has nothing to do with character formatting, so it is the one that will not italicise the selection.
Please log in or register to report this question.
In MS Excel, Print Titles on the Page Layout tab is used to
Answer: B
Correct answer: repeat chosen rows or columns on every printed page
Print Titles repeats chosen rows or columns on every printed page - typically the header row of a long table, so that a reader of page seven still knows what each column contains. It is set from Page Setup on the Page Layout tab, where Rows to repeat at top and Columns to repeat at left take a reference such as $1:$1. It is frequently confused with Freeze Panes, and the distinction is worth fixing: Freeze Panes affects only the screen and has no effect whatever on printing, while Print Titles affects only printing and does nothing on screen. A long table usually wants both. The neighbouring print controls are worth knowing together. Print Area restricts what is printed. Fit to scales the sheet to a set number of pages. Page Break Preview shows and lets you drag the page boundaries. And Print Gridlines and Print Headings add the grid and the row and column labels, neither of which prints by default.
Please log in or register to report this question.
A typical worksheet has …. Number of columns
Answer: B
Correct answer: 256
A worksheet in Excel up to 2003 has 256 columns, A to IV. Excel 2007 raised it to 16,384.
Please log in or register to report this question.
You can show the shortcut menu during the slide show by
Answer: B
Correct answer: Right clicking the current slide
During a slide show the toolbars are hidden. Right-clicking anywhere on the slide raises the show’s shortcut menu, with Next, Previous, Go to Slide, Pointer Options, Screen and End Show. The formatting toolbar is not on screen during a show, so there is no button to click.
Please log in or register to report this question.
If you press …., the cell accepts your typing as its contents.
Answer: A
Correct answer: Enter
Enter commits what has been typed and moves to the next cell. Ctrl + Enter commits it to every cell of a selection at once, and Esc abandons it.
Please log in or register to report this question.
Documentation should include
Answer: D
Correct answer: All of the above
Documentation should record where the input comes from, where the output goes and who uses it, and what the workbook is for - everything a person who did not build it would need.
Please log in or register to report this question.
You can set Page Border in Excel from
Answer: D
Correct answer: You can not set page border in Excel
Excel has cell borders but no page border: the page setup offers margins, headers, footers and gridlines, and nothing that draws a frame round the sheet. That is a Word feature.
Please log in or register to report this question.
The size of the organization chart object
Answer: D
Correct answer: b and c
The organization chart object is placed by the presentation design, which fixes its default size - but that size is not locked: you can drag its handles to resize it, and it also grows or shrinks with the amount of text the chart holds. So both the “determined by the design but can be changed” statement and the “dependent on the amount of text” statement are true, which is why the combined choice is right and the “cannot be changed” option is wrong.
Please log in or register to report this question.
To insert three columns between columns D and E you would
Answer: B
Correct answer: Select column E
Inserted columns appear before the selection, so selecting column E puts the new column between D and E. To insert three, select three columns starting at E.
Please log in or register to report this question.
