Question

Task Instructions X Record a macro to be stored in This Workbook, with the title \textbf{Location} and the letter q as a shortcut key. The macro should perform the following steps: Type $=IF(D4>25,\text{\"Workshop\"},\text{\"Office\"})$ in the selected cell, press ENTER, and then stop recording the macro. 5:48 PM 3/25/2020

          Task Instructions
X
Record a macro to be stored in This Workbook, with the
title \textbf{Location} and the letter q as a shortcut key. The
macro should perform the following steps: Type
$=IF(D4>25,\text{\"Workshop\"},\text{\"Office\"})$ in the selected cell,
press ENTER, and then stop recording the macro.
5:48 PM
3/25/2020

Task Instructions
X
Record a macro to be stored in This Workbook, with the
title Location and the letter q as a shortcut key. The
macro should perform the following steps: Type
=IF(D4>25,Ẅorkshop,Öffice) in the selected cell,
press ENTER, and then stop recording the macro.
5:48 PM
3/25/2020

Added by Ryan T.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

11/14/2023

Step 1

Step 1: Click on the "View" tab in the Excel ribbon. Show more…

Show all steps

Thanks for your feedback!

record a macro to be stored Task Instructions Record a macro to be stored in This Workbook,with the title Location and the letter q as a shortcut key. The macro should perform the following steps: Type =IF(D4>25,"Workshop""Office")in the selected cell, press ENTER, and then stop recording the macro. 5:48 PM * 3/25/2020 1) 4 F12 F11 F10 delete 0