“Qtr 1, Qtr 2, Qtr 3” is an example of a
Answer: C
Correct answer: Series
Qtr 1, Qtr 2, Qtr 3 is a series - a sequence Excel recognises and can continue with the fill handle. A formula computes and a function is a named operation.
Please log in or register to report this question.
You can edit existing Excel data by pressing the
Answer: B
Correct answer: F2 key
F2 puts the active cell into edit mode with the cursor at the end of its contents, so it can be changed without retyping the whole entry.
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.
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Answer: B
Correct answer: Right click on the spreadsheet tab and select DELETE
Sheets are managed from their tabs: right-clicking a tab offers Insert, Delete, Rename, Move or Copy. Save As changes the file, not its sheets.
Please log in or register to report this question.
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
Answer: D
Correct answer: Goal Seek
Goal Seek works backwards: you say what result you want from a formula and which cell may be altered, and Excel adjusts that cell until the formula produces it. A trend line is a chart annotation and does not change anything.
Please log in or register to report this question.
what term describes a background that appears as a grainy, non smooth surface
Answer: A
Correct answer: texture
A texture fill uses a small tiled image - sand, marble, paper - which is what gives the grainy appearance. A gradient shades smoothly from one colour to another, which is the opposite of grainy.
Please log in or register to report this question.
Excel is a
Answer: D
Correct answer: A spreadsheet
Excel is a spreadsheet: a grid of cells holding values and formulas, recalculated whenever anything they depend on changes.
Please log in or register to report this question.
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
Answer: D
Correct answer: Pivot Table Report
The Pivot Table Report is one of the Office Web Components, so that a pivot table published to a web page remains interactive and can still be pivoted and filtered in the browser.
Please log in or register to report this question.
What function displays row data in a column or column data in a row?
Answer: C
Correct answer: Transpose
TRANSPOSE turns a row into a column and a column into a row. The same operation is available as the Transpose option in Paste Special.
Please log in or register to report this question.
When you insert an Excel file into a Word document, the data are
Answer: B
Correct answer: Placed in a word table
Excel's grid maps naturally onto a Word table, so a plain paste produces one. Linking or embedding are what Paste Special offers instead, and each keeps a connection to Excel that a plain paste does not.
Please log in or register to report this question.
