Excel - Basic 1

Home
MS Office Tests
Downloads
- Excel
- Word
- PowerPoint
TestsFiles
Blog
Contact Us
Privacy Policy

United Computer Consultants

Excel Knowledge Test
Beginner Level 1
General

Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.

* Indicates required field

Name *

First

Last

Email *

What is an Excel "function"? *

A meeting at Microsoft A pre-written formula A cell containing data An error message

How many rows are there in a worksheet in Excel 2007, 2010, and 2013 *

100 2,345,000 1,048,576 16,384

Which function adds numbers? *

Vlookup Average If Sum

How many worksheets appear by default in a new file? *

1 2 3 4

What symbol precedes all formulas? *

$ & = ? #

When the right mouse button is clicked a .... appears *

Menu Formula Chart New worksheet Email program

Which keyboard shortcut enters the current date? *

Shift-* Ctrl-; Ctrl-)

How many columns are there in a worksheet in Excel 2007, 2010 and 2013? *

23,480 16,384 256

A cell is populated with data after typing by ...(click all that apply) *

Pressing the Enter key Clicking on another cell Pressing Ctrl-Enter

Excel is great for ...... (click all that apply) *

Budgeting Writing a novel Creating charts

Click the graphic to subscribe BEFORE submitting your answers

Submit my answers

Click the audio player above to hear answers and helpful tips

Note that ads appear on various pages, which may generate income for United Computer Consultants.
Visitors to this site are free to use the ads at their discretion but in no way does United Computer Consultants request such usage.
Without exception, we abide by the rules governing the display of advertising on the site.

© United Computer Consultants 2020. All rights reserved

Excel Knowledge Test Beginner Level 1 GeneralComplete the test first, then listen to the answers by clickingon the audio player at the bottom of the page.

Excel Knowledge Test
Beginner Level 1
General

Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.