MIS & TABLEAU FINAL ASSESSMENT

How to remove borders applied in Cells? 

• 1. Select None on Border tab of Format cells

• 1. Open the list on Border tool in Format Cell toolbar then choose first tool (none)

• 1. Both of above

• 1. None of above

_____ is not a valid data type in MS-Excel. 

• 1. Number

• 1. Character

• 1. Label

• Date/ Time

_____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise. 

• OR

• AND

• IF

• ANDIF

The Greater Than sign (>) exemplifies a/an _____ operator.

• 1. Arithmetic

• 1. Conditional

• 1. Logical 

• 1. Greater

____ type of chart is good for a single series of data.

• 1. Column chart

• 1. Cone chart

• 1. Line chart

• 1. Pie chart

What do Excel formulas start with? 

• /

• f

• =

• -

Why is the =COUNTIF function in Excel used? 

• 1. Counts cells as specified

• 1. Counts blank cells in a range

• 1. Counts cells with numbers in a range

• 1. Returns values based on a TRUE or FALSE condition

___ is the programming language used to write a Macro in MS Excel.

• 1. Visual basic

• 1. C+

• 1. Java

• 1. C++

What is the shortcut key to switch between worksheets in Excel?

• Ctrl+Tab

• Ctrl+Page Up

• Ctrl+Page Down

• Alt+Tab

Which of the following functions is used to calculate the average of a range of cells, ignoring zero values?

• AVERAGE

• AVERAGEIF

• AVERAGEIFS

• AGGREGATE