YEAR 4 WEEK 6 AND 7 Questions

Name the keyboard shortcuts use to switch between open excel window

• Ctrl+Tab

• Alt+Tab

• Ctrl +alt+ Tab

• None of above

The greater then sign (>) exemplifies an.................. operator

• Arithmetic

• Conditional

• Logical

• Greater

.......................... is not a valid data type in Microsoft Excel

• Numbers

• Character

• Label

• Database

How to remove borders applied in cells?

• Select none on the border tab of format cell

• Open the list on the border tool in the format cell toolbar then choose the first tool

• Both of above

• none of the above

What do excel formulas start with

• /

• F

• =

• _

.................. types chart is good for a single series of data

• Column chart

• Line chart

• Cone chart

• Pie chart

.................is not a function in excel

• SUM

• MIN

• SUBTRACT

• MAX

The intersection of a column and a row in a worksheet is called

• Column

• address

• value

• Cell

What happens when you click on ctrl + x after selecting some cell in excel

• the cell content of selected cell disappears from the cell and is stored in a clipboard

• value in the cell selected is marked for cutting

• The selected cell are deleted and the cell shifted left

• the selected cell are deleted and cells are shifted up

Ctrl + S can be used to ..................... on MS excel

• Save

• save as

• start new workbook

• switch between the opened tab