Charts tips can
Answer: D
Correct answer: b and c
A chart tip appears when the pointer rests on part of a chart, and it names the series and gives the value of the point under the pointer. It says nothing about formatting.
Please log in or register to report this question.
The Name box
Answer: B
Correct answer: Appears t the left of the formula bar
The Name box sits at the left of the formula bar. It shows the reference of the active cell and can be typed into to jump to a cell or to name a range.
Please log in or register to report this question.
How do you change column width to fit the contents?
Answer: D
Correct answer: All of above
Any of the three fits the column to its contents: double-clicking the boundary at the right of the heading, and the equivalent gestures the question lists. The right boundary is the one that belongs to that column.
Please log in or register to report this question.
when you work with large worksheets, you may need to
Answer: D
Correct answer: all of above
A large sheet needs all three: scaling so that it fits a stated number of pages, page breaks placed where they make sense, and a print area limiting what is printed at all.
Please log in or register to report this question.
Hyperlinks cannot be
Answer: D
Correct answer: All can be hyperlinks
A hyperlink can be attached to a cell, to a picture, to a drawing object and to an AutoShape alike, so none of the three is excluded.
Please log in or register to report this question.
You can use the horizontal and vertical scroll bars to
Answer: B
Correct answer: View different rows and columns
Scroll bars change which part of the sheet is displayed and nothing else - the active cell and the contents are untouched. Splitting panes is a separate command, though the split box sits at the end of the scroll bar.
Please log in or register to report this question.
What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.
Answer: A
Correct answer: Spreadsheet program
A program organising data in a grid of rows and columns, with formulas recalculated as values change, is a spreadsheet.
Please log in or register to report this question.
You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Answer: D
Correct answer: Picture
The Insert Picture From File button is on the Picture toolbar, which appears whenever a picture is selected.
Please log in or register to report this question.
To drag a selected range of data to another worksheet in the same workbook, use the
Answer: D
Correct answer: Ctrl key
Dragging within a sheet moves the data; dragging between sheets needs Ctrl held down so that the pointer can cross the sheet tabs and drop onto another sheet.
Please log in or register to report this question.
When creating a vertical page break
Answer: C
Correct answer: The active cell must be in row 1
A vertical page break is inserted to the left of the active cell and runs the full height of the sheet. Selecting a cell in row 1 gives a purely vertical break; a cell further down would produce a horizontal break as well.
Please log in or register to report this question.
