Excel

For MS Excel 2010, total Rows number is 1048576, for Columns is 16384.

What is the intersection of a column and a row on a worksheet called

A. Column

B. Value

C. Address

D. Cell ✌🏻

Which function in Excel tells the number of cells that contain numbers

A. AND

B. COUNT ✌🏻

C. SUM

D. IF

An Excel file is generally called a/an

A. Spreadsheet

B. Worksheet

C. Workbook ✌🏻

D. Sheet

A feature that displays just the columns or rows according to specified criteria

A. Formula

B. Sorting

C. Filtering ✌🏻

D. freeze columns or rows

Is a built-in function in Excel that is categorized as a Statistical Function

A. MIN

B. MAX

C. COUNT

D. All of the above ✌🏻

Creating and formatting workbooks in order to analyze data and make more informed decisions can be done with

A. Excel ✌🏻

B. Tiktok 

C. Snapchat 

D. Instagram 

What type of chart will you use to compare changes to different groups over the same period of time (useful for showing changes over time)

A. Line graph chart ✌🏻

B. Bar chart

C. Column chart

D. Pie chart

Which one is not a Function in MS Excel 

A. SUM

B. AVG ✌🏻

C. MAX

D. MIN

*الصحيح AVERAGE

Functions in MS Excel must begin with

A. Argument

B. (=) equals sign ✌🏻

C. Syntax

D. Function name

Which functionin Excel checks whether a condition is true or not

A. SUM

B. COUNT

C. IF ✌🏻

D. AVERAGE

How many sheets are there, by default, when we create a new Excel file

A. Three

B. 3

C. The half of 6

D. All of the above ✌🏻

In Excel, Columns are labelled as

A. (A, B, C, ...) ✌🏻

B. (1,2,3, ...) *correct for Rows 

C. (A1, A2, ...)

D. (1A, 2A, ...)

A cell range that included cells A1, A2, A3, A4, and A5 would be written as 

A. A1-A5

B. A1,A5

C. A1/A5

D. A1:A5 ✌🏻

Example of logical function in Excel

A. AND

B. OR

C. MAX

D. The first two choices ✌🏻

The process of arranging the items of a column in some sequence or order is known as :

A. Arrange 

B. Autofill

C. Sort ✌🏻

D. Filter

What type of chart used to compare parts of a whole (mostly expressed as percentages)

A. Line graph chart 

B. Bar chart

C. Column chart

D. Pie chart ✌🏻

What type of chart used to compare groups

A. Line graph chart 

B. Bar & Column chart ✌🏻

C. Pie chart 

D. Not mentioned