Excel | MCQs

Explanation

 An Excel macro is an action or a set of actions that can be recorded, named, saved and executed as many times as required and whenever desired.

By using macros, we are able to automate repetitive tasks associated with data manipulation and data reporting that must be accomplished repeatedly.

Explanation

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

Explanation

A bar chart or bar graph is a chart or graph that presents categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

The bars can be plotted vertically or horizontally.

A vertical bar chart is sometimes called a column chart

**** 

RY19012023

Explanation

=SUM(A1:A5)/(10-10) is not calculated in excel because 10-10 is zero so something divided by zero is not defined in the excel function.

***

ND18-1-2023

****

RY17-012-23

Explanation

In MS excel, a range identifies a range by the cells located at diagonally opposed corners.

 A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range.

AGM 17-12-2022

Explanation

The active cell displays the results of its formula while we see the formula itself in the Formula Bar. 

Explanation

The quickest way to select a range of data on your worksheet is to use Ctrl+Shift+8.

Explanation

In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.

Explanation

The formula tab allows you to select from over 300 Excel functions.

Explanation

Referred to as a cell pointer, current cell, or selected cell, an active cell is a rectangular box that highlights the cell in a spreadsheet.