Excel 1
What is Microsoft Excel
A spreadsheet Program
A workbook in Excel is
A collection of worksheets
The intersection of a row and column is called a
Cell
Which of the following is a column heading, (a)1 (b) A (c) sheet 1 (d) formula
B) A
What key is commonly used to go to the next cell (a) Shift (b) Ctrl (c) Tab (d) Alt
(c) Tab
What symbol must every formula begin with
Equal sign (=)
Which formula adds the values in cells A1 through A5
=Sum(A1:A5)
Which formula calculates the average of cell B1:B5
=Average(B1:B5)
What is used to save a workbook. (a) CTRL+P (b) CTRL+C (c) CTRL+S (d) CTRL+X
CTRL+S
Which tab contains commands for changing font style and size (a) home (b) review (c) data (d) view
(a) home
What is the default file extension for Excel (a) .docx (b).apptx (c) .xlsx (d) .txt
(c) xlxs
Which shortcut/command is used to copy data
(a) CTRL+X (b) CTRL+C (c) CTRL+V (d) CTRL+Z
(b) CTRL+C
which command is used to paste copied data
(a) CTRL+P (b) CTRL+A (c) CTRL+V (d) CTRL+D
(c) CTRL+V
What does CTRL+Z do
(a) save (b) undo (c) redo (d) print
(b) undo
Which chart is best for showing parts of a whole. (a)bar chart, (b)line chart, (c)pie chart, (d)scatter chart
(c) pie chart
What is a worksheet.
(a) a chart (b) a page within a workbook
(c) a formula (d) a menu
(b) a page within a workbook
What is the purpose of AutoFill
(a) delete data (b) automatically fill cells with data patterns (c)create charts (d) save files
(b) automatically fill cells with data patterns
which button allows you to sort data alphabetically
(a) filter (b) merge (c) sort A to Z (d) wrap text
(c) sort A to Z
Which Excel feature hides rows that do not meet certain criteria
(a) filter (b) zoom (c) format painter (d) freeze panes
(a) filter
Which function find the largest number in a range
(a) MIN (b) LARGE (c) MAX (d) HIGH
(c) MAX
What is the formula bar used for
(a) viewing and editing cell contents
(b) creating worksheets
(c) printing documents
(e) saving files
(a) viewing and editing cell contents
Which option combines multiple cells into one
(a) wrap text (b) merge and center (c) format cell
(d) insert
(b) merge and center
Which tab is used to insert charts (a) home (b) data
(c) insert (d) review
(c) insert
What is a range in Excel (a) a group of selected cells
(b) a worksheet (c) a chart (d) a formula
(a) a group of cells selected cells
Which feature keeps row or column heading visible while scrolling (a) filter (b) freeze panes (c) autofill
(d) sort
(b) freeze panes