Microsoft Excel test P5
In the article below, Network Administrator will send you more useful information about Excel software through the following quiz. Let's see how much you know about Excel.
- Question 1. To protect a sheet by password, we must enter:
- The File select Protection selects Protect Sheet
- Tools select Protection to select Protect Sheet
- Edit select Protection and select Protect Sheet
- Data select Protection and select Protect Sheet
-
- Question 2. Address $ AC $ 3 is the address
- Relatively
- Absolute
- Mixture
- Wrong performance
-
- Question 3. To format the data in column TB1 is the one-digit number type in the decimal part, we select the data column, click on the Format command menu, select:
- Cells
- Column
- AutoFormat
- Conditional Formatting
-
- Question 4. To close (turn off) an open spreadsheet (workbook) without closing the MS Excel program, which of the following methods do you use?
- Go to the File menu, select the Close command
- Go to the File menu, select the Exit command
- Go to the File menu, select the Quit command
- Click on the close icon (x) in the top right corner of the window
-
- Question 5. To count the number of SV graded Reached and Not reached as shown, in cell D9, we use the function:
- SUMIF
- COUNTIF
- COUNT
- VLOOKUP
-
- Question 6. To represent the percentage data, using the following chart is the most appropriate:
- Column chart stand (Column)
- Dispersion chart XY (XY Scatter)
- Curved line chart (Line)
- Round fan chart (Pie)
-
- Question 7. To select all cells on the worksheet with the keystroke you select:
- Press Ctrl + A
- Press Ctrl + All
- Press Ctrl + Alt + Space
- Both first and third ways are fine
-
- Question 8. To hide or display toolbars, select any of the following items:
- Go to the File menu, select the Page Setup command
- Go to the View command menu, select the Toolbars command
- Go to the Insert menu, select the Object command
- Go to the Tools menu, select the Options command
-
- Question 9. To save an open spreadsheet under another name, go to the File menu, select the command:
- Open
- Save
- Save As
- Send To
-
- Question 10. To print a horizontal or vertical sheet, choose which action
- Go to File - Web Page Preview - Choose a vertical or horizontal style
- Go to Format - Borders and Shading - Choose a vertical or horizontal style
- Go to File - Page Setup - Choose a vertical or horizontal style
- Go to Insert - Page Number - Choose a vertical or horizontal style
-
4 ★ | 1 Vote
You should read it
- Test your understanding of Excel
- A complete guide to Excel 2016 (Part 4): How to store and share spreadsheets
- Simple way to convert Excel files to PDF
- Complete tutorial of Excel 2016 (Part 3): How to create and open existing spreadsheets
- How to save Excel file to PDF format
- How to display 0 in front of a number in Excel
- Instructions on how to copy formulas in Excel
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- Instructions for inserting a PDF file into Excel spreadsheet
- How to convert Excel files to PDF online using Google Drive
- How to save Excel file contains VBA Macros code
- How to copy Word data to Excel keeps formatting
Maybe you are interested
Tinder integrates a new AI tool to automatically select the most suitable profile photo for users
How to round the corners of a selection in Photoshop is simple and easy
Fix error The selected disk has an MBR partition table when installing Windows, MBR - GPT hard drive error
4 ways to select multiple files on Mac
Solve the Error of No Photos Selected on the Phone
How to Select All on Mac