Total votes: 0


1.

Assume you are copying cell A1 to cell C3. If cell A1 contains the formula =$B1+$C$1, how would this formula change when copied to cell C3?

=$B3+$C$1: 0
=$B3+C$1: 0
=$D3+$E$3: 0
=$D3+$E1: 0


2.

When a cell is cut and pasted into a new cell, what will be pasted in the destination cell?

Any content (e.g. text, numbers, formula) and formatting of the original cell.: 0
Any content (e.g. text, numbers, formula) of the original cell.: 0
Only conditional formatting rules of the original cell.: 0
Only formatting of the original cell.: 0
Only text or number content of the original cell.: 0


3.

 Which of the following features cannot be found in the Data ribbon?

Data Validation: 0
PivotTable: 0
Text to Columns: 0
What-If Analysis: 0


4.

Number of working days

Which of the following will calculate the number of working days between the start and end date above considering the listed holidays?

DATEDIF(B1,C1,"d"): 0
NETWORKDAYS(B1,C1,F3:F5): 0
YEARFRAC(B1,C1,1): 0
YEARFRAC(B1,C1,4): 0


5.

Hashtags

Which function would you use to remove the hashtags from the input and match the output?

Alter: 0
IF(): 0
Match: 0
Substitute: 0


6.

Income Tax

Which function would you use to calculate Income Tax?

COMPUTE(): 0
IFS(): 0
SUMIFS(): 0
VLOOKUP(): 0


7.

What is a Goal Seek?

It is used to achieve your objective by changing the dependent value.: 0
It is used to filter the Table, Pivot Table data.: 0
It is used to validate the Data in a cell/Range.: 0
It is used when you have multiple variables, and you want to see the effect on the final result when these variables change.: 0


8.

What is Scenario Manager?

It is used to achieve your objective by changing the dependent value.: 0
It is used to filter the Table, Pivot Table data.: 0
It is used to validate the Data in a cell/Range.: 0
It is used when you have multiple variables, and you want to see the effect on the final result when these variables change.: 0


9.

Pivort Chrt

What would you use on this Pivot chat to create an isolated display of information relating to Harare?

Isolate(): 0
Slicer: 0
Split(): 0
Timeline: 0


10.

Psychometric Tests

 

Loction

Which PivotChart Field would you adjust to having made the displayed change?

Axis (Categories): 0
Filter: 0
Legend (Series): 0
Values: 0


11.

Which of the following is not a Value Field summary option?

Count: 0
CoVaR: 0
Sum: 0
Varp: 0


12.

Which of the following is used in regression analysis?

Column Graph: 0
PivotChart: 0
Scatter Plot: 0
Statistic Chart: 0


13.

Which function would return "TRUE" when a series of criteria are all met?

AND(): 0
IF(): 0
OR(): 0
WHILE(): 0


14.

Which function would you use to split data in a single column into multiple columns?

CUT(): 0
REPLACE(): 0
SPLIT(): 0
TEXT TO COLUMN: 0





Thank you for going through this resource! If you find this helpful please LIKE, SHARE and SUBSCRIBE to our channel and click the notifications bell to get notified whenever we post a new video. We post everyday except on Weekends. You can subscribe now by clicking on the button below.

Why should you subscribe to our Youtube channel today? Subscribing to our channel helps you discover what's new & trending globally with regards to HR and business. Watch must-see videos, from employee to organisational education to the current business world and the Internet phenomena. The last handful of years saw a surge in the popularity of videos therefore you shouldn't miss out on trending content. This is because, videos are useful for more than entertainment and it has revolutionised how people connect. We have different types of videos on our hub which include demo videos, brand videos, event videos, expert interviews, educational or How-To videos, explainer videos, case study videos, testimonial videos, live videos etc.You can also catch up on our Podcasts if you are not interested in wathing videos. Thank you for watching if you have already started to watch or videos! If you find this helpful please LIKE, SHARE and SUBSCRIBE to our channel and click the notifications bell to get notified whenever we post a new video. We post everyday except on Weekends.